<%@ page language="java" contentType="application/vnd.ms-excel; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib uri="/tld/c" prefix="c"%>
<%@ taglib uri="/tld/fmt" prefix="fmt" %>
<%@ taglib uri="/tld/fn" prefix="fn"%>
<c:set var="ctx" value="${pageContext.request.contextPath}"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ko" lang="ko">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=7;IE=8;IE=9" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="imagetoolbar" content="no" />
<meta name="robots" content="index,follow" />
<%
  response.setHeader("Content-Type", "application/vnd.ms-xls");
  response.setHeader("Content-Disposition", "inline; filename=samplefile.xls");
%>
<title>엑셀다운</title>
</head>
<body>
<table border="1">
 <tr>
  <th>이름</th>
  <th>e-mail</th>
  <th>회사명</th>
  <th>업무구분</th>
  <th>부서명</th>
  <th>직책</th>
  <th>산업군</th>
  <th>우편번호</th>
  <th>주소</th>
  <th>DM 수령지</th>
  <th>전화번호</th>
  <th>핸드폰</th>
  <th>Fax</th>
 </tr>
<c:if test="${list !=null && fn:length(list)>0 }">
	<c:forEach var="map" items="${list}" varStatus="status">
 <tr>
  <td>${map.au_name }</td>
  <td>${map.au_email }</td>
  <td>${map.au_cpn }</td>
  <td>${map.au_gubun_n }</td>
  <td>${map.au_dept }</td>
  <td>${map.au_level }</td>
  <td>${map.au_detail_gubun }</td>
  <td>${map.zip1 }-${map.zip2 }</td>
  <td>${map.addr1 } ${map.addr2 }</td>
  <td>${map.dm_area_n }</td>
  <td>${map.tel }</td>
  <td>${map.phone }</td>
  <td>${map.fax }</td>
 </tr>
	</c:forEach>
</c:if>
 
</table>
</body>
</html>
